HCL Notes and Domino Application Development wiki: Developing Applications: Run Lotus Notes Text Data via URL in JDeveloper

Run Lotus Notes Text Data via URL in JDeveloper

Added by ~Zelda Frokrotexettu | Edited by ~Zelda Frokrotexettu on September 7, 2015 | Version 13

Actions ▼

Abstract

No abstract provided.

Tags: JDeveloper, Xpages, JavaAgent, JSF

Knowledge Sharing

Döcu Content

Read Lotus Notes Data via URL in JDeveloper

Xpages/JSF Application

Introduction:

Read App Data from Lotus Notes Database into Java Server Faces Page on JDeveloper, running on Weblogic Server

Current Lotus Notes JavaAgent, code running the actual TXT file shown in the URL

Site URL

http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt

/**

* Created from copy: 2015.07.04.12.39.PM

* HTTPDDECSVDataJDevJavaAgent

* CSV data for Xpages to be read by Oracle JDeveloper Apps

load imports

import lotus.domino.*;

import lotus.domino.local.Database;

import java.io.PrintWriter;

/**

* @author Dököll Solutions, Inc.

* @version 2015.07.04.12.39.PM

begin class

public class JavaAgent extends AgentBase {

open method, this actually runs the whole App

public void NotesMain() {

let's add a try catch here, to grab errors near the end

try {

open our session...

Session session = getSession();

load info to console for debugging purposes

System.out

.println("HTTPDDECSVDataJDevJavaAgent System User, We've got a session..."

+ session);

load agentContext

AgentContext agentContext = session.getAgentContext();

...

System.out.println("got HTTPDDECSVDataJDevJavaAgent agentContext..."

+ agentContext);

find database based on session found

Database database = (Database) agentContext.getCurrentDatabase();

Find view in question according to current database

View view = database.getView("IssuesListings");

System.out.println("View Obtained..." + view);

declare document variables

Document currDoc;

Document tempDoc;

grab first doc

currDoc = view.getFirstDocument();

PrintWriter...

PrintWriter pw = getAgentOutput();

System.out

.println("URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt");

Content type set at Txt

TODO: Figure out a better version to load a CSV file to browser

currently, the csv downloads to local directory

pw.println("Content-type:text/txt");

while (currDoc != null) {

write records from view into a Text file and show it in the

browser

pw.println(currDoc.getItemValueString("UserID") + " "

+ currDoc.getItemValueString("PageID") + " "

+ currDoc.getItemValueString("priority") + " "

+ currDoc.getItemValueString("issues"));

Get next document

tempDoc = view.getNextDocument(currDoc);

recycle currDoc

currDoc.recycle();

set currDoc to tempDoc

currDoc = tempDoc;

}

} catch (Exception e) {

e.printStackTrace();

}

JDeveloper Test Log

Second attempt to connect JDeveloper with Lotus Notes

*** Using HTTP port 7101 ***

*** Using SSL port 7102 ***

C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\DefaultDomain\bin\startWebLogic.cmd

[Starting IntegratedWebLogicServer.]

[waiting for the server to complete its initialization...]

JAVA Memory arguments: -Xms256m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=512m

CLASSPATH=C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\features\com.oracle.db.jdbc7-dms.jar;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\lib\tools.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic_sp.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic.jar;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\net.sf.antcontrib_1.1.0.0_1-0b3\lib\ant-contrib.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\modules\features\oracle.wls.common.nodemanager_2.0.0.0.jar;C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\internal\features\jrf_wlsFmw_oracle.jrf.wls.classpath_12.1.3.jar;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\com.oracle.cie.config-wls-online_8.1.0.0.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derbynet.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derbyclient.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\common\derby\lib\derby.jar;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\xqrl.jar;C:\PROGRA~2\OPENOF~1.ORG\Basis\program;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JCOMMO~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JFREEC~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\POI-25~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\POI-35~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\csvjdbc.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\JASPER~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\iReport.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~1.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~2.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~3.JAR;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\ITEXT-~1.JAR;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc4.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\DB2JCC~1.JAR;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\java\Common.jar;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\COMMON~1.PRO;C:\PROGRA~2\IBM\Lotus\Notes\jvm\lib\ext\CO49EF~1.JAR

PATH=;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\native\win\x64;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\bin;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\org.apache.ant_1.9.2\bin;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\jre\bin;C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\bin;C:\app\ADMINI~1\product\112~1.0\dbhome_4\BIN;C:\PROGRA~1\COMMON~1\MICROS~1\WINDOW~1;C:\PROGRA~2\COMMON~1\MICROS~1\WINDOW~1;C:\Windows\System32;C:\Windows;C:\Windows\System32\wbem;C:\Windows\System32\WINDOW~1\v1.0\;C:\PROGRA~2\COMMON~1\ROXIOS~1\DLLSHA~1\;c:\PROGRA~2\MI3EDC~1\100\Tools\Binn\;c:\PROGRA~2\MI3EDC~1\100\Tools\Binn\VSShell\Common7\IDE\;c:\PROGRA~2\MI3EDC~1\100\DTS\Binn\;C:\PROGRA~2\WIC4A1~1\Shared;C:\PROGRA~2\COMMON~1\SOFTIM~1;C:\PROGRA~1\COMMON~1\SOFTIM~1;C:\PROGRA~1\IBM\SQLLIB\BIN;C:\PROGRA~1\IBM\SQLLIB\FUNCTION;C:\PROGRA~1\IBM\SQLLIB\samples\repl;C:\PROGRA~1\INTERN~1;C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\native\win\x64\oci920_8

***************************************************

* To start WebLogic Server, use a username and *

* password assigned to an admin-level user. For *

* server administration, use the WebLogic Server *

* console at http:\\hostname:port\console *

***************************************************

starting weblogic with Java version:

java version "1.7.0_51"

Java(TM) SE Runtime Environment (build 1.7.0_51-b13)

Java HotSpot(TM) 64-Bit Server VM (build 24.51-b03, mixed mode)

Starting WLS with line:

C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\bin\java -server -Xms256m -Xmx512m -XX:PermSize=128m -XX:MaxPermSize=512m -Dweblogic.Name=DefaultServer -Djava.security.policy=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server\lib\weblogic.policy -Doracle.jdeveloper.adrs=true -Dweblogic.nodemanager.ServiceEnabled=true -Xverify:none -Djava.endorsed.dirs=C:\Oracle\MIDDLE~1\ORACLE~2\ORACLE~1\jdk\jre\lib\endorsed;C:\Oracle\MIDDLE~1\ORACLE~2\oracle_common\modules\endorsed -Djava.protocol.handler.pkgs="oracle.mds.net.protocol" -Dopss.version=12.1.3 -Digf.arisidbeans.carmlloc=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\carml -Digf.arisidstack.home=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\arisidprovider -Doracle.security.jps.config=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\jps-config.xml -Doracle.deployed.app.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\servers\DefaultServer\tmp\_WL_user -Doracle.deployed.app.ext=\- -Dweblogic.alternateTypesDirectory=C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.ossoiap_12.1.3,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.oamprovider_12.1.3,C:\Oracle\Middleware\Oracle_Home\oracle_common\modules\oracle.jps_12.1.3 -Dweblogic.jdbc.remoteEnabled=false -Dcommon.components.home=C:\Oracle\Middleware\Oracle_Home\oracle_common -Djrf.version=12.1.3 -Dorg.apache.commons.logging.Log=org.apache.commons.logging.impl.Jdk14Logger -Ddomain.home=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1 -Doracle.server.config.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig\servers\DefaultServer -Doracle.domain.config.dir=C:\Users\ADMINI~1\AppData\Roaming\JDEVEL~1\SYSTEM~1.100\DEFAUL~1\config\fmwconfig -Doracle.mds.filestore.preferred=true -Dadf.version=12.1.3 -da -Dwls.home=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server -Dweblogic.home=C:\Oracle\MIDDLE~1\ORACLE~2\wlserver\server -Djps.app.credential.overwrite.allowed=true -Djavax.management.builder.initial=weblogic.management.jmx.mbeanserver.WLSMBeanServerBuilder -Djava.util.logging.manager=oracle.core.ojdl.logging.ODLLogManager weblogic.Server

Jul 04, 2015 12:58:37 PM oracle.security.jps.JpsStartup start

INFO: Jps initializing.

Jul 04, 2015 12:58:50 PM oracle.security.jps.internal.idstore.util.LibOvdUtil pushLdapNamesToLibOvd

INFO: Pushed ldap name and types info to libOvd. Ldaps : DefaultAuthenticator:idstore.ldap.provideridstore.ldap.

Jul 04, 2015 12:58:57 PM oracle.security.jps.JpsStartup start

INFO: Jps started.

2015-07-04 12:59:32.724/112.272 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Loaded operational configuration from "jar:file:/C:/Oracle/Middleware/Oracle_Home/coherence/lib/coherence.jar!/tangosol-coherence.xml"

2015-07-04 12:59:32.970/112.518 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Loaded operational overrides from "jar:file:/C:/Oracle/Middleware/Oracle_Home/coherence/lib/coherence.jar!/tangosol-coherence-override-dev.xml"

2015-07-04 12:59:33.410/112.958 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "/tangosol-coherence-override.xml" is not specified

2015-07-04 12:59:33.462/113.010 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "cache-factory-config.xml" is not specified

2015-07-04 12:59:33.500/113.048 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "cache-factory-builder-config.xml" is not specified

2015-07-04 12:59:33.564/113.112 Oracle Coherence 12.1.3.0.0 (thread=[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)', member=n/a): Optional configuration override "/custom-mbeans.xml" is not specified

Oracle Coherence Version 12.1.3.0.0 Build 52031

Grid Edition: Development mode

Jul 04, 2015 12:59:57 PM oracle.dms.servlet.DMSServletFilter setEagerlySetContextValues

INFO: The setting that controls the eager fetching of some types of execution context data has been set to true.

IntegratedWebLogicServer startup time: 514642 ms.

[IntegratedWebLogicServer started.]

[Running application MyWebNews on IntegratedWebLogicServer...]

[02:12:16 PM] Web Module ViewControllerWebApp.war recognized in project ViewController.jpr

[02:12:21 PM]

Deployment started.

[02:12:21 PM] Target platform is (Weblogic 12.x).

[02:13:10 PM] Retrieving existing application information

[02:13:11 PM] Running dependency analysis...

[02:13:11 PM] Deploying 2 profiles...

[02:13:14 PM] Wrote Web Application Module to C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\o.j2ee\drs\MyWebNews\ViewControllerWebApp.war

[02:13:17 PM] Wrote Enterprise Application Module to C:\Users\Administrator\AppData\Roaming\JDeveloper\system12.1.3.0.41.140521.1008\o.j2ee\drs\MyWebNews

[02:13:17 PM] Deploying 1 data source(s) to the server...

[02:13:24 PM] Redeploying Application...

[02:17:31 PM] Application Redeployed Successfully.

[02:17:33 PM] The following URL context root(s) were defined and can be used as a starting point to test your application:

[02:17:33 PM] http://localhost:7101/MyWebNews-ViewController-context-root

[02:17:33 PM] Elapsed time for deployment: 5 minutes, 12 seconds

[02:17:33 PM]

Deployment finished.

Run startup time: 316008 ms.

[Application MyWebNews running on IntegratedWebLogicServer]

JDeveloper JSF URL

Target URL -- http://localhost:7101/MyWebNews-ViewController-context-root/faces/jdlotusfeed.jsf

<_checkTimestamp>

Lotus Notes Data in JDeveloper Console

AlienHouse http://localhost/docucontent.nsf/xpissuesformnewuser.xsp Low Testing

username107 http://localhost/docucontent.nsf/xpusersubmit.xsp Low I need more Cow Bells

Notes Log

07/04/2015 01:12:35 PM XSP Command Manager initialized
07/04/2015 01:12:35 PM No statistics block. HTTP load statistics will not be collected
07/04/2015 01:12:35 PM HTTP Server: Started
07/04/2015 01:13:28 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 01:13:28 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 01:13:28 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 01:13:28 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 01:13:47 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 01:13:47 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 01:13:47 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 01:13:47 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 02:19:06 PM HTTP JVM: HTTPDDECSVDataJDevJavaAgent System User, We've got a session...CN=cherizards/O=cherizards
07/04/2015 02:19:06 PM HTTP JVM: got HTTPDDECSVDataJDevJavaAgent agentContext...CN=cherizards/O=cherizards
07/04/2015 02:19:07 PM HTTP JVM: View Obtained...IssuesListings
07/04/2015 02:19:08 PM HTTP JVM: URL: http://localhost/docucontent.nsf/javaagentfeedcsvexternalsites.txt
07/04/2015 02:27:15 PM XSP Command Manager terminated
07/04/2015 02:28:19 PM HTTP Server: Shutdown